You are here: 1. Distribution System > 1.5. INVENTORY Menu: Purchasing and Stock Control > 1.5.14. Inventory - Adjustments > 1.5.14.6. Inventory - Adjustments - Price Update > Maintaining the Price Update Batch Header
Maintaining the Price Update Batch Header

Whenever you create a new price update batch, or load an existing one, Micronet displays the Create Price Update Batch screen where you enter the main details of the batch. Micronet uses these details to automatically collate all the items to which the price update applies and calculate the new prices for those items. You can then amend the items on an individual basis using the Enter Price Update Linescreen (refer to "Entering Price Update Lines").

  1. Create a new price update batch.

Refer to "Creating a New Price Update Batch".

  1. Alternatively, load an existing price update batch and select HEADER from the Price Update Batch screen.

Refer to "Recalling a Price Update Batch".

Micronet displays the Create Price Update Batch screen.

  1. Complete the following fields:

 

Field

Value

 

Description

Micronet displays the batch description entered when the batch was created. You can change this description if required. For example, if you are using an old batch as a template, you can enter an updated description for the batch, e.g. "Updates for Supplier XYZ 10/11/10".

 

Source File

Select the file containing the prices you want to update. Options are:

  • Item file - to update prices for specific items
  • Suppliers Part file - to update prices for items for specific suppliers
  • Special Price file - to update special prices only
  • Debtors Contract file - to update item prices in a specific debtor's contract.

 

Source Field

Select the price category you want to update. Micronet displays the appropriate categories according to your selection in the Source File field. For example, if you want to update your buy prices, you would select a buy price category.

 

Destination File

Select the file where you want the new prices saved. Options are:

  • Item file - to save new prices for specific items
  • Suppliers Part file - to save new prices for items for specific suppliers
  • Special Price file - to save new special prices only
  • Debtors Contract file - to save new item prices in a specific debtor's contract.

 

Destination Field

Select the price category you want the new prices saved to.

 

 

Technical Tip

You must select both a source and a destination for every price update.

For example, if you simply want to update your existing Buy 8 prices by say 5%, you would select Buy 8 in both the Source and Destination fields.

However, if you want to update your sell prices based on a particular buy price, you might select, for example, Buy 8 in the Source field and Sell 8 in the Destination field.

 

 

Best Practice

You can also use these fields to create a backup of your original prices before processing the price updates. For example, if you are going to change your Buy 6 prices, you could copy Buy 6 to another category that is not being used (e.g. Buy 1).

 

 

Processing Order

Select the index order that you want the price updates processed in. Your selection in this field affects the range of items you can enter in the next two fields. For example, if you select Item Number, you can enter a range of items in the next two fields; if you select Bin Number, you can enter a range of bins.

 

Starting Item/Bin, etc.

For the index selected in the Processing Order field, enter the starting number to which price updates should be applied.

 

Ending Item/Bin, etc.

For the index selected in the Processing Order field, enter the ending number to which price updates should be applied.

 

 

Technical Tip

If you leave the Starting and Ending fields blank, Micronet applies price updates to all items.

 

 

Processing Type

Select how you want prices updated. Options are:

  • Percentage – update prices by a percentage amount
  • Adjustment – update prices by a net amount.

This applies to the values you enter in the Adjustment Amount fields.

 

Recalculate

Select how you want Micronet to calculate the price updates:

  • Markups – Micronet applies the price updates you enter on this screen as the markups for the items
  • Prices using Current Markups – Micronet applies the price updates you enter on this screen then applies the current markups for each item from the Item master file (refer to "File - Inventory - Sell Price")
  • Prices using Desired Markups - Micronet applies the price updates you enter on this screen then applies the desired markups for each item from the Item master file (refer to "File - Inventory - Desired Markup").

 

Adjustment Amount

The fields enabled in this section of the screen depend on your selection in the Source Field field.

 

Price 1 - 8

Enter the percentage or adjustment amount by which the selected item prices should be updated.

 

Rounding

These fields allow you to select how Micronet applies rounding to various price ranges. For example:

  • for prices between $0.00 and $5.00, you might want Micronet to round to the nearest 1 cent
  • for prices between $5.01 and $50.00, you might want Micronet to round to the nearest 5 cents
  • for prices from $50.01 and up, you might want Micronet to round up to the nearest 10 cents.

 

From

For each rounding range, enter the lower amount to which the rounding applies.

 

To

For each rounding range, enter the upper amount to which the rounding applies.

 

Round To

For each rounding range, enter the amount Micronet should round to.
  1. Select CREATE ITEMS.

Micronet collates all the items to be updated and calculates their new prices based on your entries.

  1. Select PROCEED or press F2.

Micronet redisplays the Price Update Batch screen with all the items in the batch.

Refer to "Price Update Overview" for the next steps.